﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DealerJudge.Data
{
    public interface ISqlHelper
    {
        DataTable ExecuteDataTable(CommandType commandType, string commandText);

        DataTable ExecuteDataTable(CommandType commandType, string commandText,
                                    List<IDbDataParameter> parameters);

        

        DataTable ExecuteDataTable(IDatabaseConnection databaseConnection, CommandType commandType, string commandText,
                                   List<IDbDataParameter> parameters);
        int ExecuteNonQuery(CommandType commandType, string commandText);

        int ExecuteNonQuery(CommandType commandType, string commandText,
                            List<IDbDataParameter> parameters);

        int ExecuteNonQuery(IDatabaseConnection databaseConnection, CommandType commandType, string commandText);


        int ExecuteNonQuery(IDatabaseConnection databaseConnection, CommandType commandType, string commandText,
                            List<IDbDataParameter> parameters);

        int ExecuteNonQueryBatch(IEnumerable<IDbCommand> commands);

    }
}
